#!/bin/sh
hive -e "create table if not exists xm02dw.ple_info(
ple_id string,
ple_name string,
cust_id string,
cust_name string,
ple_type string,
describefly string,
quantity_area string,
m_unit string,
ple_value string,
currency string,
ple_term string,
ple_rate string,
s_time string,
custody_dept string,
custodian_id string,
custodian string,
ple_cid string,
contract_id string,
own_cert_id string,
ple_status string,
eva_agency string,
eva_date string,
val_period string,
loc string,
risk_ass string,
remarks string,
ins_id string,
manager_id string,
create_time string,
update_time string,
etl_time string
)
row format delimited fields terminated by ',';"
echo $?